package com.tencent.mapper;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;


public interface RistMapper {

    @Select("select level from t_member where id=#{id}")
    String selectLevle(Integer id);

    @Update("update t_member set level=#{gender} where id=#{id}")
    void update(String gender,Integer id);

    @Select("select member_id from t_level where member_id=#{id}")
    Integer selectId(Integer id);

    @Insert("insert into t_level(one,member_id) values (#{gender},#{id})")
    void insert1(String gender,Integer id);

    @Insert("insert into t_level(two,member_id) values (#{gender},#{id})")
    void insert2(String gender,Integer id);

    @Update("update t_level set one=#{gender} where member_id=#{id}")
    void update1(String gender,Integer id);

    @Update("update t_level set two=#{gender} where member_id=#{id}")
    void update2(String gender,Integer id);

    @Select("select one from t_level where member_id=#{id}")
    String selectone(Integer id);

    @Select("select two from t_level where member_id=#{id}")
    String selecttwo(Integer id);
}
